package com.cooper.dao.core;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.Insert;
import net.paoding.rose.jade.annotation.ReturnGeneratedKeys;
import net.paoding.rose.jade.annotation.SQL;

import com.cooper.entity.EmailServerSetting;

@DAO
public interface EmailSettingDAO {
	
	static final String TABLE_NAME = "ext_mail_server_settting";
	
	@ReturnGeneratedKeys
	@Insert(tableName=TABLE_NAME)
	Long saveEntity(EmailServerSetting setting) throws Exception;
	
	@SQL("select * from ext_mail_server_setting where deleted='n' and email_type=:1 ")
	EmailServerSetting getSetting(String emailType) throws Exception;
	
}
